package com.huadi.bili_hot.dao.mapper;

import com.huadi.bili_hot.entity.Recommend;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface RecommendMapper {
    @Select("select * from bestcinema where type = \"番剧\" order by follow desc")
    List<Recommend> selectBangumiRec();

    @Select("select * from bestcinema where type = \"电视剧\" order by follow desc")
    List<Recommend> selectTvRec();

    @Select("select * from bestcinema where type = \"电影\" order by views desc")
    List<Recommend> selectMovieRec();

    @Select("select * from bestcinema order by views desc")
    List<Recommend> selectBestList();
}
